package cn.stylefeng.guns.modular.comment.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;


/**
 * 评论聚合汇总表
 * @author allen
 * @date 2021/4/12 10:26
 * @version 1.0
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName(value = "comment_aggregate")
public class CommentAggregateEntity implements Serializable {
    /**
     * 主键
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    /**
     * 商品ID
     */
    @TableField(value = "goods_id")
    private Long goodsId;

    /**
     * 评论总数量
     */
    @TableField(value = "total_comment_count")
    private Long totalCommentCount;

    /**
     * 好评数量
     */
    @TableField(value = "good_comment_count")
    private Long goodCommentCount;

    /**
     * 好评率
     */
    @TableField(value = "good_comment_rate")
    private BigDecimal goodCommentRate;

    /**
     * 晒图评论数量
     */
    @TableField(value = "show_pictures_comment_count")
    private Long showPicturesCommentCount;

    /**
     * 中评数量
     */
    @TableField(value = "medium_comment_count")
    private Long mediumCommentCount;

    /**
     * 差评数量
     */
    @TableField(value = "bad_comment_count")
    private Long badCommentCount;

    /**
     * 创建时间
     */
    @TableField(value = "gmt_create")
    private Date gmtCreate;

    /**
     * 更新时间
     */
    @TableField(value = "gmt_modified")
    private Date gmtModified;

    private static final long serialVersionUID = 1L;

    public static final String COL_ID = "id";

    public static final String COL_GOODS_ID = "goods_id";

    public static final String COL_TOTAL_COMMENT_COUNT = "total_comment_count";

    public static final String COL_GOOD_COMMENT_COUNT = "good_comment_count";

    public static final String COL_GOOD_COMMENT_RATE = "good_comment_rate";

    public static final String COL_SHOW_PICTURES_COMMENT_COUNT = "show_pictures_comment_count";

    public static final String COL_MEDIUM_COMMENT_COUNT = "medium_comment_count";

    public static final String COL_BAD_COMMENT_COUNT = "bad_comment_count";

    public static final String COL_GMT_CREATE = "gmt_create";

    public static final String COL_GMT_MODIFIED = "gmt_modified";
}